Line and Stacked column Visual 16

Visual 2: Line and Stacked Column Visual =: Deaths Per Mth /%YoY, %MoM by Event Type

Fields Tab

Step 1

·         Shared Axis: Event_Type

·         Column Values: Deaths Per Mth

·         Line Values: %YoY, %MoM

Format Tab

·         General: X Position = 231, Y Position = 410, Width = 515, Height = 294

·         Maintain layer order = off

Step 2

Legend: On, Position = Top, Title = off, Color = #00000, font family = DIN, Text size = 10, Style = Markers Only, circle defaut icon = on

X Axis: Color = #000000, Text Size = 9, Font family = Segoe UI, Minimum category width = 20, Maximum Size = 25%, Inner Padding = 20%, Concatenate labels = On, Title = Off

Y Axis: Position = Left, Scale Type = Linear, start = Auto, End = Auto, Color = #000000, Text size = 10, Font family = Segoe UI, Display Units = Auto, Value Decimal places = Auto, Title = Off,   Grid line = on, Line color = #CCCCCC, Stork width = 2, Line style = Doted, Show secondary = on, Aline zeros = off

Step 3

 Zoom Slider = off

Data Colors, YoY% = #E1A204, MoM = #33DBFF, Show all = on, (Color = #000000)

 Data Label = On, Color = #FFFFFF, Display Units = Auto, Value Decimal places = 2, Orientation = Horizontal, Position = Auto, Text Size = 9, Font Family = DIN, Show Background = off, Customize series = off

Shapes: Shade area = On, Stroke width = 3, Join Type = Round, Line Style = Solid, show marker = 0n, Marker size = 5, Marker color = #FFFFFF, stepped = off, customize series = on, %YoY, Shad area = on, Stork width = 3, Join type = round, Show maker = on, Marker Size = 5, Marker color = E1A204, Stepped = off

Plot Area: Transparency = 0%

Step 4

Title = On, Title Text = By Event Type, Title Heading = Heading 3; Word wrap = On, font color = #FFFFFF, Background color = #000000, Alignment = Center, Text Size = 15, Font Family = Segoe UI

Background: On, color = #FFFFF, Transparency = 0%

Lock Aspect = off

 Border: Color = #E6E6E6, Radius = 0 px

Shadow: Off

Tooltip = On, Type = Report Page, Page = Auto, Label Text color = #C8C8C8, Value text color = #EAEAEA, Text size = 9, Font family = Segoe UI, Background color = #333333, Transparency = 5%

Visual header = On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon color = #333333, Visual information icon = On, Visual warning icon = On, Visual error icon = on, Drill on drop down = On, Drill up icon = On, Drill down icon = On, Show next level icon = On, Expand to next level icon = On, Expand to next level icon = on, Pin icon = On, Focus mode icon = On, Filter icon = On, See data layout icon = On, More Options icon = On, Visual Header tooltip icon = off

Step 5

Select “Filter” From “View” menu then in Filter click “event type” then select the following type:



 

Use the following step by step Gif to create the second visual

for Step 1


for Step 2


for Step 3

for Step 4


for Step 5


Line and Stacked Column Chart in Power BI

https://www.tutorialgateway.org/line-and-stacked-column-chart-in-power-bi/